<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_store_main`;");
E_C("CREATE TABLE `ecs_store_main` (
  `store_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_name` varchar(255) NOT NULL,
  `parent_id` smallint(5) unsigned NOT NULL COMMENT '库房与仓库通过这个字段产生从属关系',
  `province` int(10) unsigned NOT NULL,
  `city` int(10) unsigned NOT NULL,
  `district` int(10) unsigned NOT NULL,
  `mianji` varchar(50) NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '入驻商店铺id',
  `store_type_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '仓库类型id',
  PRIMARY KEY (`store_id`),
  KEY `supplier_id` (`supplier_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='仓库与库房'");
E_D("replace into `ecs_store_main` values('1','华北区','0','0','0','0','','0','0');");
E_D("replace into `ecs_store_main` values('2','东北区','0','0','0','0','','0','0');");
E_D("replace into `ecs_store_main` values('3','沈阳仓','2','3428','3431','3439','100','0','0');");
E_D("replace into `ecs_store_main` values('4','北京仓','1','2','52','502','200','0','0');");
E_D("replace into `ecs_store_main` values('7','海港区','0','0','0','0','','18','18');");
E_D("replace into `ecs_store_main` values('8','海港区仓库','7','10','145','1194','1000','18','18');");
E_D("replace into `ecs_store_main` values('9','河北区','0','0','0','0','','22','22');");
E_D("replace into `ecs_store_main` values('10','北京区','0','0','0','0','','22','22');");
E_D("replace into `ecs_store_main` values('11','东直门仓库','10','2','52','500','2000','22','22');");
E_D("replace into `ecs_store_main` values('12','石塘路仓','9','10','145','1195','2000','22','22');");

require("../../inc/footer.php");
?>